timesten-ds.xml

例5.1に、TimesTenデータソースのサンプル構成ファイルを示します。

例5.1

<?xml version="1.0" encoding="UTF-8"?> 
<!-- ===================================================================== --> 
<!--                                                                       --> 
<!--  TimesTen datasource configurations                                   --> 
<!--                                                                       --> 
<!-- ===================================================================== --> 
<!-- TimesTen local transaction datasources --> 
<datasources> 
  <local-tx-datasource> 
    <jndi-name>TimesTenLocalDS</jndi-name> 
    <connection-url>jdbc:timesten:JBOSS</connection-url> 
    <driver-class>com.timesten.jdbc.TimesTenDriver</driver-class> 
    <user-name>jboss</user-name> 
    <password>jboss</password> 
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> 
    <!--pooling parameters--> 
    <min-pool-size>5</min-pool-size> 
    <max-pool-size>100</max-pool-size> 
    <blocking-timeout-millis>5000</blocking-timeout-millis> 
    <idle-timeout-minutes>15</idle-timeout-minutes> 
    <prepared-statement-cache-size>32</prepared-statement-cache-size> 
    <!-- sql to call when connection is created --> 
    <new-connection-sql>SELECT * FROM SYS.TABLES</new-connection-sql> 
    <!-- sql to call on an existing pooled connection when it is obtained from pool --> 
    <check-valid-connection-sql> 
 SELECT * FROM SYS.TABLES 
    </check-valid-connection-sql> 
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml --> 
    <metadata> 
       <type-mapping>TimesTen</type-mapping> 
    </metadata> 
  </local-tx-datasource> 
  <local-tx-datasource> 
    <jndi-name>TimesTenLocalClientDS</jndi-name> 
    <connection-url>jdbc:timesten:client:JBOSS_CS</connection-url> 
    <driver-class>com.timesten.jdbc.TimesTenDriver</driver-class> 
    <user-name>jboss</user-name> 
    <password>jboss</password> 
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> 
    <!--pooling parameters--> 
    <min-pool-size>5</min-pool-size> 
    <max-pool-size>100</max-pool-size> 
    <blocking-timeout-millis>5000</blocking-timeout-millis> 
    <idle-timeout-minutes>15</idle-timeout-minutes> 
    <prepared-statement-cache-size>32</prepared-statement-cache-size> 
    <!-- sql to call when connection is created --> 
    <new-connection-sql>SELECT * FROM SYS.TABLES</new-connection-sql> 
    <!-- sql to call on an existing pooled connection when it is obtained from pool --> 
    <check-valid-connection-sql> 
 SELECT * FROM SYS.TABLES 
    </check-valid-connection-sql> 
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml --> 
    <metadata> 
       <type-mapping>TimesTen</type-mapping> 
    </metadata> 
  </local-tx-datasource> 
  <!-- TimesTen XA transaction datasources --> 
  <xa-datasource> 
    <jndi-name>TimesTenXADS</jndi-name> 
    <xa-datasource-class> 
 com.timesten.jdbc.xa.TimesTenXADataSource 
    </xa-datasource-class> 
    <xa-datasource-property name="Url"> 
 jdbc:timesten:JBOSS 
    </xa-datasource-property> 
    <user-name>jboss</user-name> 
    <password>jboss</password> 
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> 
    <!--pooling parameters--> 
    <min-pool-size>5</min-pool-size> 
    <max-pool-size>100</max-pool-size> 
    <blocking-timeout-millis>5000</blocking-timeout-millis> 
    <idle-timeout-minutes>15</idle-timeout-minutes> 
    <prepared-statement-cache-size>32</prepared-statement-cache-size> 
    <!-- This is required by TimesTen XA data sources. If it is not included 
         then XA transactions can fail with various transaction management 
         errors including javax.transaction.xa.XAException: errorCode=XAER_PROTO  
    --> 
    <track-connection-by-tx/> 
   
  
    <!-- sql to call when connection is created --> 
    <new-connection-sql>SELECT * FROM SYS.TABLES</new-connection-sql> 
    <!-- sql to call on an existing pooled connection when it is obtained from pool --> 
    <check-valid-connection-sql> 
 SELECT * FROM SYS.TABLES 
    </check-valid-connection-sql> 
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml --> 
    <metadata> 
       <type-mapping>TimesTen</type-mapping> 
    </metadata> 
  </xa-datasource> 
  <xa-datasource> 
    <jndi-name>TimesTenXAClientDS</jndi-name> 
    <xa-datasource-class> 
 com.timesten.jdbc.xa.TimesTenXADataSource 
    </xa-datasource-class> 
    <xa-datasource-property name="Url"> 
 jdbc:timesten:client:JBOSS_CS 
    </xa-datasource-property> 
    <user-name>jboss</user-name> 
    <password>jboss</password> 
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> 
    <!--pooling parameters--> 
    <min-pool-size>5</min-pool-size> 
    <max-pool-size>100</max-pool-size> 
    <blocking-timeout-millis>5000</blocking-timeout-millis> 
    <idle-timeout-minutes>15</idle-timeout-minutes> 
    <prepared-statement-cache-size>32</prepared-statement-cache-size> 
   
    <!-- This is required by TimesTen XA data sources. If it is not included 
         then XA transactions can fail with various transaction management 
         errors including javax.transaction.xa.XAException: errorCode=XAER_PROTO  
    --> 
    <track-connection-by-tx/> 
  
    <!-- sql to call when connection is created --> 
    <new-connection-sql>SELECT * FROM SYS.TABLES</new-connection-sql> 
    <!-- sql to call on an existing pooled connection when it is obtained from pool --> 
    <check-valid-connection-sql> 
 SELECT * FROM SYS.TABLES 
    </check-valid-connection-sql> 
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml --> 
    <metadata> 
       <type-mapping>TimesTen</type-mapping> 
    </metadata> 
  </xa-datasource> 
  <!-- TimesTen persistent JMS data source --> 
  <xa-datasource> 
    <jndi-name>TimesTenJMS</jndi-name> 
    <xa-datasource-class> 
 com.timesten.jdbc.xa.TimesTenXADataSource 
    </xa-datasource-class> 
    <xa-datasource-property name="Url"> 
 jdbc:timesten:JBOSS_JMS 
    </xa-datasource-property> 
    <user-name>jboss</user-name> 
    <password>jboss</password> 
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> 
    <!--pooling parameters--> 
    <min-pool-size>5</min-pool-size> 
    <max-pool-size>100</max-pool-size> 
    <blocking-timeout-millis>5000</blocking-timeout-millis> 
    <idle-timeout-minutes>15</idle-timeout-minutes> 
    <prepared-statement-cache-size>32</prepared-statement-cache-size> 
    <!-- This is required by TimesTen XA data sources. If it is not included 
         then XA transactions can fail with various transaction management 
         errors including javax.transaction.xa.XAException: errorCode=XAER_PROTO  
    --> 
    <track-connection-by-tx/> 
   
  
    <!-- sql to call when connection is created --> 
    <new-connection-sql>SELECT * FROM SYS.TABLES</new-connection-sql> 
    <!-- sql to call on an existing pooled connection when it is obtained from pool --> 
    <check-valid-connection-sql> 
 SELECT * FROM SYS.TABLES 
    </check-valid-connection-sql> 
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml --> 
    <metadata> 
       <type-mapping>TimesTen</type-mapping> 
    </metadata> 
  </xa-datasource> 
</datasources> 

---

前へ 次へ

Copyright © 2006, Oracle. All rights reserved.

目次 索引